Platform Explorer / Nuxeo Platform LTS 2017 9.10

Contribution org.nuxeo.ecm.platform.search.pageproviders--providers

In component org.nuxeo.ecm.platform.search.pageproviders
This contribution is part of XML component org.nuxeo.ecm.platform.search.pageproviders inside nuxeo-search-core-9.10.jar /OSGI-INF/savedsearch-pageprovider-contrib.xml

Extension Point

Extension point providers of component PageProviderService.

Contributed Items

  • <coreQueryPageProvider name="SAVED_SEARCHES_ALL">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND ((saved:query IS NOT NULL AND saved:queryLanguage IS NOT NULL)
              OR saved:providerName IS NOT NULL)
        AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>
  • <coreQueryPageProvider name="SAVED_SEARCHES_ALL_PAGE_PROVIDER">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND ((saved:query IS NOT NULL AND saved:queryLanguage IS NOT NULL)
              OR saved:providerName IS NOT NULL)
        AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND saved:providerName = :pageProvider
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>
  • <coreQueryPageProvider name="SAVED_SEARCHES">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND cvd:contentViewName IS NOT NULL
        AND dc:creator = ? AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
    </coreQueryPageProvider>
  • <coreQueryPageProvider name="SHARED_SAVED_SEARCHES">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND cvd:contentViewName IS NOT NULL
        AND dc:creator != ? AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
    </coreQueryPageProvider>

XML Source

<extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">

    <coreQueryPageProvider name="SAVED_SEARCHES_ALL">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND ((saved:query IS NOT NULL AND saved:queryLanguage IS NOT NULL)
              OR saved:providerName IS NOT NULL)
        AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="SAVED_SEARCHES_ALL_PAGE_PROVIDER">
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND ((saved:query IS NOT NULL AND saved:queryLanguage IS NOT NULL)
              OR saved:providerName IS NOT NULL)
        AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND saved:providerName = :pageProvider
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="SAVED_SEARCHES">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND cvd:contentViewName IS NOT NULL
        AND dc:creator = ? AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="SHARED_SAVED_SEARCHES">
      <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
      <pattern>
        SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
        AND cvd:contentViewName IS NOT NULL
        AND dc:creator != ? AND ecm:isProxy = 0
        AND ecm:isCheckedInVersion = 0
        AND ecm:currentLifeCycleState != 'deleted'
        AND SORTED_COLUMN IS NOT NULL
      </pattern>
      <sort ascending="true" column="dc:title"/>
    </coreQueryPageProvider>

  </extension>